Purpose |
Change the fields format to text in the excel file and remove leading zeros to material and SO. |
Release No |
002 |
Submitted on |
05/26/2016 |
Submitted by |
Deepak Yasam |
Environment |
NECNED to NECNEQ |
Sent To |
Rizwan Shah |
Object(s) created by |
Damodar Sanagana |
Object(s) tested by |
Deepak Yasam |
Transport Status |
Created in NECNED100 |
Sl. |
Transport ID |
Description |
Object Name |
1 |
NEDK934865 |
SD:22066:File format changes in Commercial Inv. Excel Email |
ZSF00010_EMEA_IB_OB ZMM_PO_PRINT_EXCEL |
Test ID |
Test Scenario |
Expected Result |
SO |
PO |
OBD |
P/F |
Notes |
Tested By |
QA By |
SD-001 |
1. Create ZOR order 2. Create Delivery w/o PGI 3. Issue ZECO output manually |
The items should be displayed in the commercial invoice form though PGI is not done. |
1949144 |
NA |
82071929 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-002 |
1.Create ZOR order with three items 2. Create Delivery and PGI two items 3. Issue ZECO output manually |
Only the PGI items should be displayed in the commercial invoice form. |
1949143 |
NA |
82071928 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-003 |
1.Create ZOR order and partially reject few lines 2. Create Delivery and PGI 3. Issue ZECO output manually |
Only the PGI items should be displayed in the commercial invoice form. |
1949145 |
NA |
82071930 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-004 |
1. Create ZOR order with Item category TAB 2. Create PO, Delivery and PGI 3. Issue ZECO output manually |
Only the PGI items should be displayed in the commercial invoice form. |
1949146 |
4500105024 |
82071931 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-005 |
1.Create ZPTO order 2. Create PO, Delivery and PGI 3.Issue ZECO output manually |
Only the PGI items should be displayed in the commercial invoice form. |
1949147 |
4500105025 |
82071932 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
Test ID |
Test Scenario |
Expected Result |
SO |
PO |
IBD |
P/F |
Notes |
Tested By |
QA By |
SD-001 |
1.Create ZU3P SO in 2000,10,00 sales area and corresponding SNC PO. 2. Create Inb.Del document and PGR. 3.Execute ZECO output manullay. |
All the items in the Inb del should be displayed in the commercial invoice form. |
1949108 |
4500105014 |
180011846 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-002 |
1.Create two ZU3P SO's in 2000,10,00 sales area and corresponding single PO. 2. Create Inb.Del document and PGR. 3.Execute ZECO output manually. |
All the items in the Inb del should be displayed in the commercial invoice form. |
1949109 1949110 |
4500105015 |
180011847 180011848 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-003 |
1.Create ZU3P SO in 2000,10,00 sales area and multiple SNC PO's. 2. Create Inb.Del documents and PGR. 3.Execute ZECO output manullay in each IB Delivery. |
All the items in the Inb del's should be displayed in the commercial invoice form. |
1949111 |
4500105016 4500105017 |
180011849 180011850 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-004 |
1.Create ZU3P SO in 2000,10,00 sales area and corresponding SNC PO. 2. Create Inb.Del for partial items and PGR. 3.Execute ZECO output manullay. |
All the items in the Inb del's should be displayed in the commercial invoice form. |
1949112 |
4500105018 |
180011851 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-005 |
1.Create ZU3P SO in 2000,10,00 sales area and corresponding SNC PO. 2. Create Inb.Del document and do not PGR. 3.Execute ZECO output manullay. |
The items should be displayed in the commercial invoice form |
1949113 |
4500105019 |
180011852 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-006 |
1.Create two ZU3P SO's in 2000,10,00 sales area and corresponding single PO. 2. Create Inb.Del document and do not PGR. 3.Execute ZECO output manually. |
The items should be displayed in the commercial invoice form |
1949114 1949115 |
4500105020 |
180011853 180011854 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-007 |
1.Create ZU3P SO in 2000,10,00 sales area and multiple SNC PO's. 2. Create Inb.Del document and do not PGR. 3.Execute ZECO output manullay in each IB Delivery. |
The items should be displayed in the commercial invoice form |
1949116 |
4500105021 4500105022 |
180011855 180011856 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-008 |
1. Create ZU3P SO in 2000,10,00 sales area and reject 1st size of each size. Then create corresponding SNC PO. 2. Create inb. Del document and do the PGR. 3. Execute ZECO output manually in each IB Delivery. |
Items should be displayed in the commercial invoice form as the PGR is done with correct unit price and total price. |
1949153 |
4500105026 |
180011857 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
Test ID |
Test Scenario |
Expected Result |
SO |
PO |
MIGO/ INB DEL. |
P/F |
Notes |
Tested By |
QA By |
SD-001 |
1.Create ZPTO SO in 2000,10,00 sales area and corresponding NB PO. 2. Create MIGO document for all the items in the PO. 3.Execute ZECO output manullay in PO. |
All the items should be displayed in the commercial form and PO (Po type- NB) number should not be displayed. |
1949095 |
4500105001 |
5000385211 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-002 |
1.Create two ZPTO SO's in 2000,10,00 sales area and corresponding single NB PO. 2. Create MIGO document for all the items in the PO. 3.Execute ZECO output manually in PO. |
All the items should be displayed in the commercial form and PO (Po type- NB) number should not be displayed. Multiple output files should be triggered for each SO. |
1949096 1949097 |
4500105002 |
5000385212 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-003 |
1.Create ZPTO SO in 2000,10,00 sales area and multiple NB PO's. 2. Create MIGO document for all the items in the PO's. 3.Execute ZECO output manullay in each PO. |
All the items should be displayed in the commercial formand PO (Po type- NB) number should not be displayed. |
1949098 |
4500105003 4500105004 |
5000385213 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-004 |
1.Create ZPTO SO in 2000,10,00 sales area and corresponding NB PO. 2. Create MIGO document for partial items in the PO. 3.Execute ZECO output manullay in PO. |
All the items should be displayed in the commercial form . and PO (Po type- NB) number should not be displayed. |
1949099 |
4500105005 |
5000385214 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-005 |
1.Create two ZPTO SO's in 2000,10,00 sales area and corresponding single NB PO. 2. Create MIGO document for partial items in PO. 3.Execute ZECO output manually in PO. |
All the items should be displayed in the commercial form and PO (Po type- NB) number should not be displayed. Multiple output files should be triggered for each SO. |
1949100 1949101 |
4500105006 |
5000385215 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-006 |
1.Create ZPTO SO in 2000,10,00 sales area and multiple NB PO's. 2. Create MIGO document for partial items in the PO's. 3.Execute ZECO output manullay in each PO |
All the items should be displayed in the commercial form and PO (Po type- NB) number should not be displayed. |
1949102 |
4500105007 4500105008 |
5000385216 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-007 |
1.Create ZPTO SO in 2000,10,00 sales area and corresponding NB PO. 2. MIGO document is not created for the PO. 3.Execute ZECO output manullay in PO. |
The items should be displayed and PO (Po type- NB) number should not be displayed. |
1949103 |
4500105009 |
NA |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-008 |
1.Create two ZPTO SO's in 2000,10,00 sales area and corresponding single NB PO. 2. MIGO document is not created for the PO. 3.Execute ZECO output manually in PO. |
The items should be displayed and PO (Po type- NB) number should not be displayed. Multiple output files should be triggered for each SO. |
1949104 1949105 |
4500105010 |
NA |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-009 |
1.Create ZPTO SO in 2000,10,00 sales area and multiple NB PO's. 2. MIGO document is not created for the PO. 3.Execute ZECO output manullay in each PO |
The items should be displayed and PO (Po type- NB) number should not be displayed. |
1949106 |
4500105011 4500105012 |
NA |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-010 |
1.Create ZPTO SO in 2000,10,00 sales area and corresponding NB PO. 2. MIGO document is not created for the PO. 3.Execute ZECO output manullay in PO. |
The items should be displayed and PO (Po type- NB) number should not be displayed. |
1949107 |
4500105013 |
NA |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-011 |
1.Create ZPTO SO in 2000,10,00 sales area and Reject 1st size of each item and create corresponding NB PO. 2. Create MIGO document for all the items in the PO's. 3.Execute ZECO output manullay in PO. |
All the PGR items should be displayed in the commercial form with correct unit price and total price and PO (Po type- NB) number should not be displayed. |
1949154 |
4500105027 |
5000385228 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-012 |
1.Create ZU3P SO in 2000,10,00 sales area and corresponding SNC PO. 2. Create Inb.Del document and PGR. 3.Execute ZECO output manullay in PO. |
All the items in the Inb del should be displayed in the commercial invoice form. |
1949108 |
4500105014 |
180011846 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-013 |
1.Create two ZU3P SO's in 2000,10,00 sales area and corresponding single PO. 2. Create Inb.Del document and PGR. 3.Execute ZECO output manually in PO. |
All the items in the Inb del should be displayed in the commercial invoice form. Multiple output files should be triggered for each SO. |
1949109 1949110 |
4500105015 |
180011847 180011848 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-014 |
1.Create ZU3P SO in 2000,10,00 sales area and multiple SNC PO's. 2. Create Inb.Del documents and PGR. 3.Execute ZECO output manullay in each PO. |
All the items in the Inb del's should be displayed in the commercial invoice form. |
1949111 |
4500105016 4500105017 |
180011849 180011850 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-015 |
1.Create ZU3P SO in 2000,10,00 sales area and corresponding SNC PO. 2. Create Inb.Del for partial items and PGR. 3.Execute ZECO output manullay in PO. |
All the items in the Inb del's should be displayed in the commercial invoice form. |
1949112 |
4500105018 |
180011851 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-016 |
1.Create ZU3P SO in 2000,10,00 sales area and corresponding SNC PO. 2. Create Inb.Del document and do not PGR. 3.Execute ZECO output manullay in PO. |
All the items in the Inb del's should be displayed in the commercial invoice form. |
1949113 |
4500105019 |
180011852 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-017 |
1.Create two ZU3P SO's in 2000,10,00 sales area and corresponding single PO. 2. Create Inb.Del document and do not PGR. 3.Execute ZECO output manually in PO. |
All the items in the Inb del's should be displayed in the commercial invoice form. Multiple output files should be triggered for each SO. |
1949114 1949115 |
4500105020 |
180011853 180011854 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-018 |
1.Create ZU3P SO in 2000,10,00 sales area and multiple SNC PO's. 2. Create Inb.Del document and do not PGR. 3.Execute ZECO output manullay in each PO. |
All the items in the Inb del's should be displayed in the commercial invoice form. |
1949116 |
4500105021 4500105022 |
180011855 180011856 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-019 |
1. Create ZU3P SO in 2000,10,00 sales area and reject 1st size of each size. Then create corresponding SNC PO. 2. Create inb. Del document and do the PGR. 3. Execute ZECO output manually in PO. |
Items should be displayed in the commercial invoice form as the PGR is done with correct unit price and total price. |
1949153 |
4500105026 |
180011857 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-020 |
1. Create multiple ZU3P SO in 2000,10,00 sales area and Then create corresponding Z3NB PO with confirmation ZNEC. 2. Create MIGO document 3. Execute ZECO output manually in PO. |
All the items in the Inb del's should be displayed in the commercial invoice form. . Multiple output files should be triggered for each SO. |
1949167 1949168 |
4500105029 |
NA |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-021 |
1. Create multiple ZU3P SO in 2000,10,00 sales area and Then create corresponding Z3NB PO with confirmation ZNEC. 2. Create MIGO document 3. Execute ZECO output manually in PO. |
All the items in the PO should be displayed in the commercial invoice form. Multiple output files should be triggered for each SO. |
1949169 1949170 |
4500105030 |
5000385230 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-022 |
1. Create multiple ZU3P SO in 2000,10,00 sales area and Then create corresponding Z3NB PO with confirmation ZNEC. 2. Create MIGO document with partial qty. 3. Execute ZECO output manually in PO. |
All the items in the Inb del's should be displayed in the commercial invoice form. Multiple output files should be triggered for each SO. |
1949182 1949183 |
4500105031 |
5000385231 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-023 |
1. Create PO (PO Type- NB) without any reference of Sales order. 2. Don't create MIGO document 3. Execute the ZECO output manually in PO. |
Output should be triggered with blank excel sheet. |
NA |
4500105033 |
NA |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-024 |
1. Create PO (PO Type- NB) without any reference of Sales order. 2. Create MIGO document. 3. Execute the ZECO output manually in PO. |
Output should be triggered with blank excel sheet. |
NA |
4500105034 |
5000385232 |
P |
NA |
Deepak/Siba |
Deepak Yasam |